using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VKASCHEMA
    {
        public DataRow Convert2KASCHEMA(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryKASCHEMA(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["KASMANDANT"] = " ".PadRight(2 ); 
         dwReturn["KASSCHEM"] = " ".PadRight(5 ); 
         dwReturn["KASAENZL"] = " ".PadRight(0 ); 
         dwReturn["KASAENB"] = " ".PadRight(8 ); 
         dwReturn["KASAEND"] = " ".PadRight(0 ); 
         dwReturn["KASNEUB"] = " ".PadRight(8 ); 
         dwReturn["KASNEUD"] = " ".PadRight(0 ); 
         dwReturn["KASBEZ"] = " ".PadRight(40 ); 
         dwReturn["KASZTXT1"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ1"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT2"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ2"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT3"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ3"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT4"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ4"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT5"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ5"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT6"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ6"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT7"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ7"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT8"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ8"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT9"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ9"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT10"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ10"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT11"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ11"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT12"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ12"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT13"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ13"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT14"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ14"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT15"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ15"] = " ".PadRight(1 ); 
         dwReturn["KASZTXT16"] = " ".PadRight(44 ); 
         dwReturn["KASZKZ16"] = " ".PadRight(1 ); 
         dwReturn["KASSKZ"] = " ".PadRight(1 ); 
         dwReturn["KASSME1"] = " ".PadRight(1 ); 
         dwReturn["KASSBAS1"] = " ".PadRight(0 ); 
         dwReturn["KASSKZVG1"] = " ".PadRight(1 ); 
         dwReturn["KASSME2"] = " ".PadRight(1 ); 
         dwReturn["KASSBAS2"] = " ".PadRight(0 ); 
         dwReturn["KASSKZVG2"] = " ".PadRight(1 ); 
         dwReturn["KASSME3"] = " ".PadRight(1 ); 
         dwReturn["KASSBAS3"] = " ".PadRight(0 ); 
         dwReturn["KASSKZVG3"] = " ".PadRight(1 ); 
         dwReturn["KASSME4"] = " ".PadRight(1 ); 
         dwReturn["KASSBAS4"] = " ".PadRight(0 ); 
         dwReturn["KASSKZVG4"] = " ".PadRight(1 ); 
         dwReturn["KASSME5"] = " ".PadRight(1 ); 
         dwReturn["KASSBAS5"] = " ".PadRight(0 ); 
         dwReturn["KASSKZVG5"] = " ".PadRight(1 ); 
         dwReturn["KASSME6"] = " ".PadRight(1 ); 
         dwReturn["KASSBAS6"] = " ".PadRight(0 ); 
         dwReturn["KASSKZVG6"] = " ".PadRight(1 ); 
         dwReturn["KASGRENZ1"] = " ".PadRight(1 ); 
         dwReturn["KASGRENZ2"] = " ".PadRight(1 ); 
         dwReturn["KASGRENZ3"] = " ".PadRight(1 ); 
         dwReturn["KASGRENZ4"] = " ".PadRight(1 ); 
         dwReturn["KASGRENZ5"] = " ".PadRight(1 ); 
         dwReturn["KASSTUF"] = " ".PadRight(1 ); 
         dwReturn["KASKZLAE"] = " ".PadRight(1 ); 
         dwReturn["KASKZSEKVV"] = " ".PadRight(1 ); 
         dwReturn["KASKZSEKIE"] = " ".PadRight(1 ); 
         dwReturn["KASKZVKKALK"] = " ".PadRight(1 ); 
         dwReturn["KASKZKART"] = " ".PadRight(1 ); 
         dwReturn["KASKZAGANG"] = " ".PadRight(1 ); 
         dwReturn["KASKZZPROD"] = " ".PadRight(1 ); 
         dwReturn["KASKZNUTZEF"] = " ".PadRight(1 ); 
         dwReturn["KASMKG"] = " ".PadRight(2 ); 
         dwReturn["KASMGKG1"] = " ".PadRight(2 ); 
         dwReturn["KASMGKG2"] = " ".PadRight(2 ); 
         dwReturn["KASMGKG3"] = " ".PadRight(2 ); 
         dwReturn["KASMGKG4"] = " ".PadRight(2 ); 
         dwReturn["KASMGKG5"] = " ".PadRight(2 ); 
         dwReturn["KASMKKG"] = " ".PadRight(2 ); 
         dwReturn["KASMGKKG1"] = " ".PadRight(2 ); 
         dwReturn["KASMGKKG2"] = " ".PadRight(2 ); 
         dwReturn["KASMGKKG3"] = " ".PadRight(2 ); 
         dwReturn["KASMGKKG4"] = " ".PadRight(2 ); 
         dwReturn["KASMGKKG5"] = " ".PadRight(2 ); 
         dwReturn["KASMKRW"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRW1"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRW2"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRW3"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRW4"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRW5"] = " ".PadRight(2 ); 
         dwReturn["KASMKRZ"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRZ1"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRZ2"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRZ3"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRZ4"] = " ".PadRight(2 ); 
         dwReturn["KASMGKRZ5"] = " ".PadRight(2 ); 
         dwReturn["KASMKZK"] = " ".PadRight(2 ); 
         dwReturn["KASMGKZK1"] = " ".PadRight(2 ); 
         dwReturn["KASMGKZK2"] = " ".PadRight(2 ); 
         dwReturn["KASMGKZK3"] = " ".PadRight(2 ); 
         dwReturn["KASMGKZK4"] = " ".PadRight(2 ); 
         dwReturn["KASMGKZK5"] = " ".PadRight(2 ); 
         dwReturn["KASMKSO"] = " ".PadRight(2 ); 
         dwReturn["KASMGKSO1"] = " ".PadRight(2 ); 
         dwReturn["KASMGKSO2"] = " ".PadRight(2 ); 
         dwReturn["KASMGKSO3"] = " ".PadRight(2 ); 
         dwReturn["KASMGKSO4"] = " ".PadRight(2 ); 
         dwReturn["KASMGKSO5"] = " ".PadRight(2 ); 
         dwReturn["KASFEKSP1"] = " ".PadRight(2 ); 
         dwReturn["KASFEKSP2"] = " ".PadRight(2 ); 
         dwReturn["KASFEKSP3"] = " ".PadRight(2 ); 
         dwReturn["KASFEKSP4"] = " ".PadRight(2 ); 
         dwReturn["KASFEKSP5"] = " ".PadRight(2 ); 
         dwReturn["KASFGKSP1"] = " ".PadRight(2 ); 
         dwReturn["KASFGKSP2"] = " ".PadRight(2 ); 
         dwReturn["KASFGKSP3"] = " ".PadRight(2 ); 
         dwReturn["KASFGKSP4"] = " ".PadRight(2 ); 
         dwReturn["KASFGKSP5"] = " ".PadRight(2 ); 
         dwReturn["KASFFKSP"] = " ".PadRight(2 ); 
         dwReturn["KASSEKSP"] = " ".PadRight(2 ); 
         dwReturn["KASFEKG1"] = " ".PadRight(2 ); 
         dwReturn["KASFEKG2"] = " ".PadRight(2 ); 
         dwReturn["KASFEKG3"] = " ".PadRight(2 ); 
         dwReturn["KASFEKG4"] = " ".PadRight(2 ); 
         dwReturn["KASFEKG5"] = " ".PadRight(2 ); 
         dwReturn["KASFGKG1"] = " ".PadRight(2 ); 
         dwReturn["KASFGKG2"] = " ".PadRight(2 ); 
         dwReturn["KASFGKG3"] = " ".PadRight(2 ); 
         dwReturn["KASFGKG4"] = " ".PadRight(2 ); 
         dwReturn["KASFGKG5"] = " ".PadRight(2 ); 
         dwReturn["KASFFKG"] = " ".PadRight(2 ); 
         dwReturn["KASSEKG"] = " ".PadRight(2 ); 
         dwReturn["KASFEKVW1"] = " ".PadRight(2 ); 
         dwReturn["KASFEKVW2"] = " ".PadRight(2 ); 
         dwReturn["KASFEKVW3"] = " ".PadRight(2 ); 
         dwReturn["KASFEKVW4"] = " ".PadRight(2 ); 
         dwReturn["KASFEKVW5"] = " ".PadRight(2 ); 
         dwReturn["KASFGKVW1"] = " ".PadRight(2 ); 
         dwReturn["KASFGKVW2"] = " ".PadRight(2 ); 
         dwReturn["KASFGKVW3"] = " ".PadRight(2 ); 
         dwReturn["KASFGKVW4"] = " ".PadRight(2 ); 
         dwReturn["KASFGKVW5"] = " ".PadRight(2 ); 
         dwReturn["KASFFKVW"] = " ".PadRight(2 ); 
         dwReturn["KASSEKVW"] = " ".PadRight(2 ); 
         dwReturn["KASFEKW1"] = " ".PadRight(2 ); 
         dwReturn["KASFEKW2"] = " ".PadRight(2 ); 
         dwReturn["KASFEKW3"] = " ".PadRight(2 ); 
         dwReturn["KASFEKW4"] = " ".PadRight(2 ); 
         dwReturn["KASFEKW5"] = " ".PadRight(2 ); 
         dwReturn["KASFGKW1"] = " ".PadRight(2 ); 
         dwReturn["KASFGKW2"] = " ".PadRight(2 ); 
         dwReturn["KASFGKW3"] = " ".PadRight(2 ); 
         dwReturn["KASFGKW4"] = " ".PadRight(2 ); 
         dwReturn["KASFGKW5"] = " ".PadRight(2 ); 
         dwReturn["KASFFKW"] = " ".PadRight(2 ); 
         dwReturn["KASSEKW"] = " ".PadRight(2 ); 
         dwReturn["KASFEKV1"] = " ".PadRight(2 ); 
         dwReturn["KASFEKV2"] = " ".PadRight(2 ); 
         dwReturn["KASFEKV3"] = " ".PadRight(2 ); 
         dwReturn["KASFEKV4"] = " ".PadRight(2 ); 
         dwReturn["KASFEKV5"] = " ".PadRight(2 ); 
         dwReturn["KASFGKV1"] = " ".PadRight(2 ); 
         dwReturn["KASFGKV2"] = " ".PadRight(2 ); 
         dwReturn["KASFGKV3"] = " ".PadRight(2 ); 
         dwReturn["KASFGKV4"] = " ".PadRight(2 ); 
         dwReturn["KASFGKV5"] = " ".PadRight(2 ); 
         dwReturn["KASFFKV"] = " ".PadRight(2 ); 
         dwReturn["KASSEKV"] = " ".PadRight(2 ); 
         dwReturn["KASFEKK1"] = " ".PadRight(2 ); 
         dwReturn["KASFEKK2"] = " ".PadRight(2 ); 
         dwReturn["KASFEKK3"] = " ".PadRight(2 ); 
         dwReturn["KASFEKK4"] = " ".PadRight(2 ); 
         dwReturn["KASFEKK5"] = " ".PadRight(2 ); 
         dwReturn["KASFGKK1"] = " ".PadRight(2 ); 
         dwReturn["KASFGKK2"] = " ".PadRight(2 ); 
         dwReturn["KASFGKK3"] = " ".PadRight(2 ); 
         dwReturn["KASFGKK4"] = " ".PadRight(2 ); 
         dwReturn["KASFGKK5"] = " ".PadRight(2 ); 
         dwReturn["KASFFKK"] = " ".PadRight(2 ); 
         dwReturn["KASSEKK"] = " ".PadRight(2 ); 
         dwReturn["KASLAE"] = " ".PadRight(2 ); 
         dwReturn["KASLAEBAS"] = " ".PadRight(2 ); 
         dwReturn["KASWAG"] = " ".PadRight(2 ); 
         dwReturn["KASWAGBAS"] = " ".PadRight(2 ); 
         dwReturn["KASMEZ"] = " ".PadRight(2 ); 
         dwReturn["KASMEZBAS"] = " ".PadRight(2 ); 
         dwReturn["KASVERKPR"] = " ".PadRight(2 ); 
         dwReturn["KASKZGZU"] = " ".PadRight(1 ); 
         dwReturn["KASVVGK1"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK2"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK3"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK4"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK5"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK6"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK7"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK8"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK9"] = " ".PadRight(2 ); 
         dwReturn["KASVVGK10"] = " ".PadRight(2 ); 
         dwReturn["KASVERPI"] = " ".PadRight(2 ); 
         dwReturn["KASVERPE"] = " ".PadRight(2 ); 
         dwReturn["KASVERSI"] = " ".PadRight(2 ); 
         dwReturn["KASVERSE"] = " ".PadRight(2 ); 
         dwReturn["KASFRAI"] = " ".PadRight(2 ); 
         dwReturn["KASFRAE"] = " ".PadRight(2 ); 
         dwReturn["KASZOLLI"] = " ".PadRight(2 ); 
         dwReturn["KASZOLLE"] = " ".PadRight(2 ); 
         dwReturn["KASPROVI"] = " ".PadRight(2 ); 
         dwReturn["KASPROVE"] = " ".PadRight(2 ); 
         dwReturn["KASBONI"] = " ".PadRight(2 ); 
         dwReturn["KASBONE"] = " ".PadRight(2 ); 
         dwReturn["KASSKTI"] = " ".PadRight(2 ); 
         dwReturn["KASSKTE"] = " ".PadRight(2 ); 
         dwReturn["KASEVI"] = " ".PadRight(2 ); 
         dwReturn["KASEVE"] = " ".PadRight(2 ); 
         dwReturn["KASSEKSI"] = " ".PadRight(2 ); 
         dwReturn["KASSEKSE"] = " ".PadRight(2 ); 
         dwReturn["KASZINSI"] = " ".PadRight(2 ); 
         dwReturn["KASZINSE"] = " ".PadRight(2 ); 
         dwReturn["KASSDBI"] = " ".PadRight(2 ); 
         dwReturn["KASSDBE"] = " ".PadRight(2 ); 
         dwReturn["KASZUSCHLI"] = " ".PadRight(2 ); 
         dwReturn["KASZUSCHLE"] = " ".PadRight(2 ); 
         dwReturn["KASVPI"] = " ".PadRight(2 ); 
         dwReturn["KASVPE"] = " ".PadRight(2 ); 
         dwReturn["KASSCHKI"] = " ".PadRight(2 ); 
         dwReturn["KASSCHKE"] = " ".PadRight(2 ); 
         dwReturn["KASFILLER"] = " ".PadRight(61 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapKASCHEMA(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveKASCHEMA(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryKASCHEMA(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapKASCHEMA(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertKASCHEMA(dwLocal, ITXDBVERSION);
            }
            UpdateKASCHEMA(dwLocal);
        }
        public void InsertKASCHEMA(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO KASCHEMA(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryKASCHEMA(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM KASCHEMA WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM KASCHEMA  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "KASCHEMA";
            Return = Result;
            return Return;
        }
        public void DeleteKASCHEMA(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM KASCHEMA   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateKASCHEMA(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE KASCHEMA SET "
                    +"KASMANDANT= :KASMANDANT,"
                    +"KASSCHEM= :KASSCHEM,"
                    +"KASAENZL= :KASAENZL,"
                    +"KASAENB= :KASAENB,"
                    +"KASAEND= :KASAEND,"
                    +"KASNEUB= :KASNEUB,"
                    +"KASNEUD= :KASNEUD,"
                    +"KASBEZ= :KASBEZ,"
                    +"KASZTXT1= :KASZTXT1,"
                    +"KASZKZ1= :KASZKZ1,"
                    +"KASZTXT2= :KASZTXT2,"
                    +"KASZKZ2= :KASZKZ2,"
                    +"KASZTXT3= :KASZTXT3,"
                    +"KASZKZ3= :KASZKZ3,"
                    +"KASZTXT4= :KASZTXT4,"
                    +"KASZKZ4= :KASZKZ4,"
                    +"KASZTXT5= :KASZTXT5,"
                    +"KASZKZ5= :KASZKZ5,"
                    +"KASZTXT6= :KASZTXT6,"
                    +"KASZKZ6= :KASZKZ6,"
                    +"KASZTXT7= :KASZTXT7,"
                    +"KASZKZ7= :KASZKZ7,"
                    +"KASZTXT8= :KASZTXT8,"
                    +"KASZKZ8= :KASZKZ8,"
                    +"KASZTXT9= :KASZTXT9,"
                    +"KASZKZ9= :KASZKZ9,"
                    +"KASZTXT10= :KASZTXT10,"
                    +"KASZKZ10= :KASZKZ10,"
                    +"KASZTXT11= :KASZTXT11,"
                    +"KASZKZ11= :KASZKZ11,"
                    +"KASZTXT12= :KASZTXT12,"
                    +"KASZKZ12= :KASZKZ12,"
                    +"KASZTXT13= :KASZTXT13,"
                    +"KASZKZ13= :KASZKZ13,"
                    +"KASZTXT14= :KASZTXT14,"
                    +"KASZKZ14= :KASZKZ14,"
                    +"KASZTXT15= :KASZTXT15,"
                    +"KASZKZ15= :KASZKZ15,"
                    +"KASZTXT16= :KASZTXT16,"
                    +"KASZKZ16= :KASZKZ16,"
                    +"KASSKZ= :KASSKZ,"
                    +"KASSME1= :KASSME1,"
                    +"KASSBAS1= :KASSBAS1,"
                    +"KASSKZVG1= :KASSKZVG1,"
                    +"KASSME2= :KASSME2,"
                    +"KASSBAS2= :KASSBAS2,"
                    +"KASSKZVG2= :KASSKZVG2,"
                    +"KASSME3= :KASSME3,"
                    +"KASSBAS3= :KASSBAS3,"
                    +"KASSKZVG3= :KASSKZVG3,"
                    +"KASSME4= :KASSME4,"
                    +"KASSBAS4= :KASSBAS4,"
                    +"KASSKZVG4= :KASSKZVG4,"
                    +"KASSME5= :KASSME5,"
                    +"KASSBAS5= :KASSBAS5,"
                    +"KASSKZVG5= :KASSKZVG5,"
                    +"KASSME6= :KASSME6,"
                    +"KASSBAS6= :KASSBAS6,"
                    +"KASSKZVG6= :KASSKZVG6,"
                    +"KASGRENZ1= :KASGRENZ1,"
                    +"KASGRENZ2= :KASGRENZ2,"
                    +"KASGRENZ3= :KASGRENZ3,"
                    +"KASGRENZ4= :KASGRENZ4,"
                    +"KASGRENZ5= :KASGRENZ5,"
                    +"KASSTUF= :KASSTUF,"
                    +"KASKZLAE= :KASKZLAE,"
                    +"KASKZSEKVV= :KASKZSEKVV,"
                    +"KASKZSEKIE= :KASKZSEKIE,"
                    +"KASKZVKKALK= :KASKZVKKALK,"
                    +"KASKZKART= :KASKZKART,"
                    +"KASKZAGANG= :KASKZAGANG,"
                    +"KASKZZPROD= :KASKZZPROD,"
                    +"KASKZNUTZEF= :KASKZNUTZEF,"
                    +"KASMKG= :KASMKG,"
                    +"KASMGKG1= :KASMGKG1,"
                    +"KASMGKG2= :KASMGKG2,"
                    +"KASMGKG3= :KASMGKG3,"
                    +"KASMGKG4= :KASMGKG4,"
                    +"KASMGKG5= :KASMGKG5,"
                    +"KASMKKG= :KASMKKG,"
                    +"KASMGKKG1= :KASMGKKG1,"
                    +"KASMGKKG2= :KASMGKKG2,"
                    +"KASMGKKG3= :KASMGKKG3,"
                    +"KASMGKKG4= :KASMGKKG4,"
                    +"KASMGKKG5= :KASMGKKG5,"
                    +"KASMKRW= :KASMKRW,"
                    +"KASMGKRW1= :KASMGKRW1,"
                    +"KASMGKRW2= :KASMGKRW2,"
                    +"KASMGKRW3= :KASMGKRW3,"
                    +"KASMGKRW4= :KASMGKRW4,"
                    +"KASMGKRW5= :KASMGKRW5,"
                    +"KASMKRZ= :KASMKRZ,"
                    +"KASMGKRZ1= :KASMGKRZ1,"
                    +"KASMGKRZ2= :KASMGKRZ2,"
                    +"KASMGKRZ3= :KASMGKRZ3,"
                    +"KASMGKRZ4= :KASMGKRZ4,"
                    +"KASMGKRZ5= :KASMGKRZ5,"
                    +"KASMKZK= :KASMKZK,"
                    +"KASMGKZK1= :KASMGKZK1,"
                    +"KASMGKZK2= :KASMGKZK2,"
                    +"KASMGKZK3= :KASMGKZK3,"
                    +"KASMGKZK4= :KASMGKZK4,"
                    +"KASMGKZK5= :KASMGKZK5,"
                    +"KASMKSO= :KASMKSO,"
                    +"KASMGKSO1= :KASMGKSO1,"
                    +"KASMGKSO2= :KASMGKSO2,"
                    +"KASMGKSO3= :KASMGKSO3,"
                    +"KASMGKSO4= :KASMGKSO4,"
                    +"KASMGKSO5= :KASMGKSO5,"
                    +"KASFEKSP1= :KASFEKSP1,"
                    +"KASFEKSP2= :KASFEKSP2,"
                    +"KASFEKSP3= :KASFEKSP3,"
                    +"KASFEKSP4= :KASFEKSP4,"
                    +"KASFEKSP5= :KASFEKSP5,"
                    +"KASFGKSP1= :KASFGKSP1,"
                    +"KASFGKSP2= :KASFGKSP2,"
                    +"KASFGKSP3= :KASFGKSP3,"
                    +"KASFGKSP4= :KASFGKSP4,"
                    +"KASFGKSP5= :KASFGKSP5,"
                    +"KASFFKSP= :KASFFKSP,"
                    +"KASSEKSP= :KASSEKSP,"
                    +"KASFEKG1= :KASFEKG1,"
                    +"KASFEKG2= :KASFEKG2,"
                    +"KASFEKG3= :KASFEKG3,"
                    +"KASFEKG4= :KASFEKG4,"
                    +"KASFEKG5= :KASFEKG5,"
                    +"KASFGKG1= :KASFGKG1,"
                    +"KASFGKG2= :KASFGKG2,"
                    +"KASFGKG3= :KASFGKG3,"
                    +"KASFGKG4= :KASFGKG4,"
                    +"KASFGKG5= :KASFGKG5,"
                    +"KASFFKG= :KASFFKG,"
                    +"KASSEKG= :KASSEKG,"
                    +"KASFEKVW1= :KASFEKVW1,"
                    +"KASFEKVW2= :KASFEKVW2,"
                    +"KASFEKVW3= :KASFEKVW3,"
                    +"KASFEKVW4= :KASFEKVW4,"
                    +"KASFEKVW5= :KASFEKVW5,"
                    +"KASFGKVW1= :KASFGKVW1,"
                    +"KASFGKVW2= :KASFGKVW2,"
                    +"KASFGKVW3= :KASFGKVW3,"
                    +"KASFGKVW4= :KASFGKVW4,"
                    +"KASFGKVW5= :KASFGKVW5,"
                    +"KASFFKVW= :KASFFKVW,"
                    +"KASSEKVW= :KASSEKVW,"
                    +"KASFEKW1= :KASFEKW1,"
                    +"KASFEKW2= :KASFEKW2,"
                    +"KASFEKW3= :KASFEKW3,"
                    +"KASFEKW4= :KASFEKW4,"
                    +"KASFEKW5= :KASFEKW5,"
                    +"KASFGKW1= :KASFGKW1,"
                    +"KASFGKW2= :KASFGKW2,"
                    +"KASFGKW3= :KASFGKW3,"
                    +"KASFGKW4= :KASFGKW4,"
                    +"KASFGKW5= :KASFGKW5,"
                    +"KASFFKW= :KASFFKW,"
                    +"KASSEKW= :KASSEKW,"
                    +"KASFEKV1= :KASFEKV1,"
                    +"KASFEKV2= :KASFEKV2,"
                    +"KASFEKV3= :KASFEKV3,"
                    +"KASFEKV4= :KASFEKV4,"
                    +"KASFEKV5= :KASFEKV5,"
                    +"KASFGKV1= :KASFGKV1,"
                    +"KASFGKV2= :KASFGKV2,"
                    +"KASFGKV3= :KASFGKV3,"
                    +"KASFGKV4= :KASFGKV4,"
                    +"KASFGKV5= :KASFGKV5,"
                    +"KASFFKV= :KASFFKV,"
                    +"KASSEKV= :KASSEKV,"
                    +"KASFEKK1= :KASFEKK1,"
                    +"KASFEKK2= :KASFEKK2,"
                    +"KASFEKK3= :KASFEKK3,"
                    +"KASFEKK4= :KASFEKK4,"
                    +"KASFEKK5= :KASFEKK5,"
                    +"KASFGKK1= :KASFGKK1,"
                    +"KASFGKK2= :KASFGKK2,"
                    +"KASFGKK3= :KASFGKK3,"
                    +"KASFGKK4= :KASFGKK4,"
                    +"KASFGKK5= :KASFGKK5,"
                    +"KASFFKK= :KASFFKK,"
                    +"KASSEKK= :KASSEKK,"
                    +"KASLAE= :KASLAE,"
                    +"KASLAEBAS= :KASLAEBAS,"
                    +"KASWAG= :KASWAG,"
                    +"KASWAGBAS= :KASWAGBAS,"
                    +"KASMEZ= :KASMEZ,"
                    +"KASMEZBAS= :KASMEZBAS,"
                    +"KASVERKPR= :KASVERKPR,"
                    +"KASKZGZU= :KASKZGZU,"
                    +"KASVVGK1= :KASVVGK1,"
                    +"KASVVGK2= :KASVVGK2,"
                    +"KASVVGK3= :KASVVGK3,"
                    +"KASVVGK4= :KASVVGK4,"
                    +"KASVVGK5= :KASVVGK5,"
                    +"KASVVGK6= :KASVVGK6,"
                    +"KASVVGK7= :KASVVGK7,"
                    +"KASVVGK8= :KASVVGK8,"
                    +"KASVVGK9= :KASVVGK9,"
                    +"KASVVGK10= :KASVVGK10,"
                    +"KASVERPI= :KASVERPI,"
                    +"KASVERPE= :KASVERPE,"
                    +"KASVERSI= :KASVERSI,"
                    +"KASVERSE= :KASVERSE,"
                    +"KASFRAI= :KASFRAI,"
                    +"KASFRAE= :KASFRAE,"
                    +"KASZOLLI= :KASZOLLI,"
                    +"KASZOLLE= :KASZOLLE,"
                    +"KASPROVI= :KASPROVI,"
                    +"KASPROVE= :KASPROVE,"
                    +"KASBONI= :KASBONI,"
                    +"KASBONE= :KASBONE,"
                    +"KASSKTI= :KASSKTI,"
                    +"KASSKTE= :KASSKTE,"
                    +"KASEVI= :KASEVI,"
                    +"KASEVE= :KASEVE,"
                    +"KASSEKSI= :KASSEKSI,"
                    +"KASSEKSE= :KASSEKSE,"
                    +"KASZINSI= :KASZINSI,"
                    +"KASZINSE= :KASZINSE,"
                    +"KASSDBI= :KASSDBI,"
                    +"KASSDBE= :KASSDBE,"
                    +"KASZUSCHLI= :KASZUSCHLI,"
                    +"KASZUSCHLE= :KASZUSCHLE,"
                    +"KASVPI= :KASVPI,"
                    +"KASVPE= :KASVPE,"
                    +"KASSCHKI= :KASSCHKI,"
                    +"KASSCHKE= :KASSCHKE,"
                    +"KASFILLER= :KASFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("KASMANDANT", OracleType.NVarChar).Value = dwData["KASMANDANT"].ToString(); 
          or1.Parameters.Add("KASSCHEM", OracleType.NVarChar).Value = dwData["KASSCHEM"].ToString(); 
          or1.Parameters.Add("KASAENZL", OracleType.NVarChar).Value = dwData["KASAENZL"].ToString(); 
          or1.Parameters.Add("KASAENB", OracleType.NVarChar).Value = dwData["KASAENB"].ToString(); 
          or1.Parameters.Add("KASAEND", OracleType.NVarChar).Value = dwData["KASAEND"].ToString(); 
          or1.Parameters.Add("KASNEUB", OracleType.NVarChar).Value = dwData["KASNEUB"].ToString(); 
          or1.Parameters.Add("KASNEUD", OracleType.NVarChar).Value = dwData["KASNEUD"].ToString(); 
          or1.Parameters.Add("KASBEZ", OracleType.NVarChar).Value = dwData["KASBEZ"].ToString(); 
          or1.Parameters.Add("KASZTXT1", OracleType.NVarChar).Value = dwData["KASZTXT1"].ToString(); 
          or1.Parameters.Add("KASZKZ1", OracleType.NVarChar).Value = dwData["KASZKZ1"].ToString(); 
          or1.Parameters.Add("KASZTXT2", OracleType.NVarChar).Value = dwData["KASZTXT2"].ToString(); 
          or1.Parameters.Add("KASZKZ2", OracleType.NVarChar).Value = dwData["KASZKZ2"].ToString(); 
          or1.Parameters.Add("KASZTXT3", OracleType.NVarChar).Value = dwData["KASZTXT3"].ToString(); 
          or1.Parameters.Add("KASZKZ3", OracleType.NVarChar).Value = dwData["KASZKZ3"].ToString(); 
          or1.Parameters.Add("KASZTXT4", OracleType.NVarChar).Value = dwData["KASZTXT4"].ToString(); 
          or1.Parameters.Add("KASZKZ4", OracleType.NVarChar).Value = dwData["KASZKZ4"].ToString(); 
          or1.Parameters.Add("KASZTXT5", OracleType.NVarChar).Value = dwData["KASZTXT5"].ToString(); 
          or1.Parameters.Add("KASZKZ5", OracleType.NVarChar).Value = dwData["KASZKZ5"].ToString(); 
          or1.Parameters.Add("KASZTXT6", OracleType.NVarChar).Value = dwData["KASZTXT6"].ToString(); 
          or1.Parameters.Add("KASZKZ6", OracleType.NVarChar).Value = dwData["KASZKZ6"].ToString(); 
          or1.Parameters.Add("KASZTXT7", OracleType.NVarChar).Value = dwData["KASZTXT7"].ToString(); 
          or1.Parameters.Add("KASZKZ7", OracleType.NVarChar).Value = dwData["KASZKZ7"].ToString(); 
          or1.Parameters.Add("KASZTXT8", OracleType.NVarChar).Value = dwData["KASZTXT8"].ToString(); 
          or1.Parameters.Add("KASZKZ8", OracleType.NVarChar).Value = dwData["KASZKZ8"].ToString(); 
          or1.Parameters.Add("KASZTXT9", OracleType.NVarChar).Value = dwData["KASZTXT9"].ToString(); 
          or1.Parameters.Add("KASZKZ9", OracleType.NVarChar).Value = dwData["KASZKZ9"].ToString(); 
          or1.Parameters.Add("KASZTXT10", OracleType.NVarChar).Value = dwData["KASZTXT10"].ToString(); 
          or1.Parameters.Add("KASZKZ10", OracleType.NVarChar).Value = dwData["KASZKZ10"].ToString(); 
          or1.Parameters.Add("KASZTXT11", OracleType.NVarChar).Value = dwData["KASZTXT11"].ToString(); 
          or1.Parameters.Add("KASZKZ11", OracleType.NVarChar).Value = dwData["KASZKZ11"].ToString(); 
          or1.Parameters.Add("KASZTXT12", OracleType.NVarChar).Value = dwData["KASZTXT12"].ToString(); 
          or1.Parameters.Add("KASZKZ12", OracleType.NVarChar).Value = dwData["KASZKZ12"].ToString(); 
          or1.Parameters.Add("KASZTXT13", OracleType.NVarChar).Value = dwData["KASZTXT13"].ToString(); 
          or1.Parameters.Add("KASZKZ13", OracleType.NVarChar).Value = dwData["KASZKZ13"].ToString(); 
          or1.Parameters.Add("KASZTXT14", OracleType.NVarChar).Value = dwData["KASZTXT14"].ToString(); 
          or1.Parameters.Add("KASZKZ14", OracleType.NVarChar).Value = dwData["KASZKZ14"].ToString(); 
          or1.Parameters.Add("KASZTXT15", OracleType.NVarChar).Value = dwData["KASZTXT15"].ToString(); 
          or1.Parameters.Add("KASZKZ15", OracleType.NVarChar).Value = dwData["KASZKZ15"].ToString(); 
          or1.Parameters.Add("KASZTXT16", OracleType.NVarChar).Value = dwData["KASZTXT16"].ToString(); 
          or1.Parameters.Add("KASZKZ16", OracleType.NVarChar).Value = dwData["KASZKZ16"].ToString(); 
          or1.Parameters.Add("KASSKZ", OracleType.NVarChar).Value = dwData["KASSKZ"].ToString(); 
          or1.Parameters.Add("KASSME1", OracleType.NVarChar).Value = dwData["KASSME1"].ToString(); 
          or1.Parameters.Add("KASSBAS1", OracleType.NVarChar).Value = dwData["KASSBAS1"].ToString(); 
          or1.Parameters.Add("KASSKZVG1", OracleType.NVarChar).Value = dwData["KASSKZVG1"].ToString(); 
          or1.Parameters.Add("KASSME2", OracleType.NVarChar).Value = dwData["KASSME2"].ToString(); 
          or1.Parameters.Add("KASSBAS2", OracleType.NVarChar).Value = dwData["KASSBAS2"].ToString(); 
          or1.Parameters.Add("KASSKZVG2", OracleType.NVarChar).Value = dwData["KASSKZVG2"].ToString(); 
          or1.Parameters.Add("KASSME3", OracleType.NVarChar).Value = dwData["KASSME3"].ToString(); 
          or1.Parameters.Add("KASSBAS3", OracleType.NVarChar).Value = dwData["KASSBAS3"].ToString(); 
          or1.Parameters.Add("KASSKZVG3", OracleType.NVarChar).Value = dwData["KASSKZVG3"].ToString(); 
          or1.Parameters.Add("KASSME4", OracleType.NVarChar).Value = dwData["KASSME4"].ToString(); 
          or1.Parameters.Add("KASSBAS4", OracleType.NVarChar).Value = dwData["KASSBAS4"].ToString(); 
          or1.Parameters.Add("KASSKZVG4", OracleType.NVarChar).Value = dwData["KASSKZVG4"].ToString(); 
          or1.Parameters.Add("KASSME5", OracleType.NVarChar).Value = dwData["KASSME5"].ToString(); 
          or1.Parameters.Add("KASSBAS5", OracleType.NVarChar).Value = dwData["KASSBAS5"].ToString(); 
          or1.Parameters.Add("KASSKZVG5", OracleType.NVarChar).Value = dwData["KASSKZVG5"].ToString(); 
          or1.Parameters.Add("KASSME6", OracleType.NVarChar).Value = dwData["KASSME6"].ToString(); 
          or1.Parameters.Add("KASSBAS6", OracleType.NVarChar).Value = dwData["KASSBAS6"].ToString(); 
          or1.Parameters.Add("KASSKZVG6", OracleType.NVarChar).Value = dwData["KASSKZVG6"].ToString(); 
          or1.Parameters.Add("KASGRENZ1", OracleType.NVarChar).Value = dwData["KASGRENZ1"].ToString(); 
          or1.Parameters.Add("KASGRENZ2", OracleType.NVarChar).Value = dwData["KASGRENZ2"].ToString(); 
          or1.Parameters.Add("KASGRENZ3", OracleType.NVarChar).Value = dwData["KASGRENZ3"].ToString(); 
          or1.Parameters.Add("KASGRENZ4", OracleType.NVarChar).Value = dwData["KASGRENZ4"].ToString(); 
          or1.Parameters.Add("KASGRENZ5", OracleType.NVarChar).Value = dwData["KASGRENZ5"].ToString(); 
          or1.Parameters.Add("KASSTUF", OracleType.NVarChar).Value = dwData["KASSTUF"].ToString(); 
          or1.Parameters.Add("KASKZLAE", OracleType.NVarChar).Value = dwData["KASKZLAE"].ToString(); 
          or1.Parameters.Add("KASKZSEKVV", OracleType.NVarChar).Value = dwData["KASKZSEKVV"].ToString(); 
          or1.Parameters.Add("KASKZSEKIE", OracleType.NVarChar).Value = dwData["KASKZSEKIE"].ToString(); 
          or1.Parameters.Add("KASKZVKKALK", OracleType.NVarChar).Value = dwData["KASKZVKKALK"].ToString(); 
          or1.Parameters.Add("KASKZKART", OracleType.NVarChar).Value = dwData["KASKZKART"].ToString(); 
          or1.Parameters.Add("KASKZAGANG", OracleType.NVarChar).Value = dwData["KASKZAGANG"].ToString(); 
          or1.Parameters.Add("KASKZZPROD", OracleType.NVarChar).Value = dwData["KASKZZPROD"].ToString(); 
          or1.Parameters.Add("KASKZNUTZEF", OracleType.NVarChar).Value = dwData["KASKZNUTZEF"].ToString(); 
          or1.Parameters.Add("KASMKG", OracleType.NVarChar).Value = dwData["KASMKG"].ToString(); 
          or1.Parameters.Add("KASMGKG1", OracleType.NVarChar).Value = dwData["KASMGKG1"].ToString(); 
          or1.Parameters.Add("KASMGKG2", OracleType.NVarChar).Value = dwData["KASMGKG2"].ToString(); 
          or1.Parameters.Add("KASMGKG3", OracleType.NVarChar).Value = dwData["KASMGKG3"].ToString(); 
          or1.Parameters.Add("KASMGKG4", OracleType.NVarChar).Value = dwData["KASMGKG4"].ToString(); 
          or1.Parameters.Add("KASMGKG5", OracleType.NVarChar).Value = dwData["KASMGKG5"].ToString(); 
          or1.Parameters.Add("KASMKKG", OracleType.NVarChar).Value = dwData["KASMKKG"].ToString(); 
          or1.Parameters.Add("KASMGKKG1", OracleType.NVarChar).Value = dwData["KASMGKKG1"].ToString(); 
          or1.Parameters.Add("KASMGKKG2", OracleType.NVarChar).Value = dwData["KASMGKKG2"].ToString(); 
          or1.Parameters.Add("KASMGKKG3", OracleType.NVarChar).Value = dwData["KASMGKKG3"].ToString(); 
          or1.Parameters.Add("KASMGKKG4", OracleType.NVarChar).Value = dwData["KASMGKKG4"].ToString(); 
          or1.Parameters.Add("KASMGKKG5", OracleType.NVarChar).Value = dwData["KASMGKKG5"].ToString(); 
          or1.Parameters.Add("KASMKRW", OracleType.NVarChar).Value = dwData["KASMKRW"].ToString(); 
          or1.Parameters.Add("KASMGKRW1", OracleType.NVarChar).Value = dwData["KASMGKRW1"].ToString(); 
          or1.Parameters.Add("KASMGKRW2", OracleType.NVarChar).Value = dwData["KASMGKRW2"].ToString(); 
          or1.Parameters.Add("KASMGKRW3", OracleType.NVarChar).Value = dwData["KASMGKRW3"].ToString(); 
          or1.Parameters.Add("KASMGKRW4", OracleType.NVarChar).Value = dwData["KASMGKRW4"].ToString(); 
          or1.Parameters.Add("KASMGKRW5", OracleType.NVarChar).Value = dwData["KASMGKRW5"].ToString(); 
          or1.Parameters.Add("KASMKRZ", OracleType.NVarChar).Value = dwData["KASMKRZ"].ToString(); 
          or1.Parameters.Add("KASMGKRZ1", OracleType.NVarChar).Value = dwData["KASMGKRZ1"].ToString(); 
          or1.Parameters.Add("KASMGKRZ2", OracleType.NVarChar).Value = dwData["KASMGKRZ2"].ToString(); 
          or1.Parameters.Add("KASMGKRZ3", OracleType.NVarChar).Value = dwData["KASMGKRZ3"].ToString(); 
          or1.Parameters.Add("KASMGKRZ4", OracleType.NVarChar).Value = dwData["KASMGKRZ4"].ToString(); 
          or1.Parameters.Add("KASMGKRZ5", OracleType.NVarChar).Value = dwData["KASMGKRZ5"].ToString(); 
          or1.Parameters.Add("KASMKZK", OracleType.NVarChar).Value = dwData["KASMKZK"].ToString(); 
          or1.Parameters.Add("KASMGKZK1", OracleType.NVarChar).Value = dwData["KASMGKZK1"].ToString(); 
          or1.Parameters.Add("KASMGKZK2", OracleType.NVarChar).Value = dwData["KASMGKZK2"].ToString(); 
          or1.Parameters.Add("KASMGKZK3", OracleType.NVarChar).Value = dwData["KASMGKZK3"].ToString(); 
          or1.Parameters.Add("KASMGKZK4", OracleType.NVarChar).Value = dwData["KASMGKZK4"].ToString(); 
          or1.Parameters.Add("KASMGKZK5", OracleType.NVarChar).Value = dwData["KASMGKZK5"].ToString(); 
          or1.Parameters.Add("KASMKSO", OracleType.NVarChar).Value = dwData["KASMKSO"].ToString(); 
          or1.Parameters.Add("KASMGKSO1", OracleType.NVarChar).Value = dwData["KASMGKSO1"].ToString(); 
          or1.Parameters.Add("KASMGKSO2", OracleType.NVarChar).Value = dwData["KASMGKSO2"].ToString(); 
          or1.Parameters.Add("KASMGKSO3", OracleType.NVarChar).Value = dwData["KASMGKSO3"].ToString(); 
          or1.Parameters.Add("KASMGKSO4", OracleType.NVarChar).Value = dwData["KASMGKSO4"].ToString(); 
          or1.Parameters.Add("KASMGKSO5", OracleType.NVarChar).Value = dwData["KASMGKSO5"].ToString(); 
          or1.Parameters.Add("KASFEKSP1", OracleType.NVarChar).Value = dwData["KASFEKSP1"].ToString(); 
          or1.Parameters.Add("KASFEKSP2", OracleType.NVarChar).Value = dwData["KASFEKSP2"].ToString(); 
          or1.Parameters.Add("KASFEKSP3", OracleType.NVarChar).Value = dwData["KASFEKSP3"].ToString(); 
          or1.Parameters.Add("KASFEKSP4", OracleType.NVarChar).Value = dwData["KASFEKSP4"].ToString(); 
          or1.Parameters.Add("KASFEKSP5", OracleType.NVarChar).Value = dwData["KASFEKSP5"].ToString(); 
          or1.Parameters.Add("KASFGKSP1", OracleType.NVarChar).Value = dwData["KASFGKSP1"].ToString(); 
          or1.Parameters.Add("KASFGKSP2", OracleType.NVarChar).Value = dwData["KASFGKSP2"].ToString(); 
          or1.Parameters.Add("KASFGKSP3", OracleType.NVarChar).Value = dwData["KASFGKSP3"].ToString(); 
          or1.Parameters.Add("KASFGKSP4", OracleType.NVarChar).Value = dwData["KASFGKSP4"].ToString(); 
          or1.Parameters.Add("KASFGKSP5", OracleType.NVarChar).Value = dwData["KASFGKSP5"].ToString(); 
          or1.Parameters.Add("KASFFKSP", OracleType.NVarChar).Value = dwData["KASFFKSP"].ToString(); 
          or1.Parameters.Add("KASSEKSP", OracleType.NVarChar).Value = dwData["KASSEKSP"].ToString(); 
          or1.Parameters.Add("KASFEKG1", OracleType.NVarChar).Value = dwData["KASFEKG1"].ToString(); 
          or1.Parameters.Add("KASFEKG2", OracleType.NVarChar).Value = dwData["KASFEKG2"].ToString(); 
          or1.Parameters.Add("KASFEKG3", OracleType.NVarChar).Value = dwData["KASFEKG3"].ToString(); 
          or1.Parameters.Add("KASFEKG4", OracleType.NVarChar).Value = dwData["KASFEKG4"].ToString(); 
          or1.Parameters.Add("KASFEKG5", OracleType.NVarChar).Value = dwData["KASFEKG5"].ToString(); 
          or1.Parameters.Add("KASFGKG1", OracleType.NVarChar).Value = dwData["KASFGKG1"].ToString(); 
          or1.Parameters.Add("KASFGKG2", OracleType.NVarChar).Value = dwData["KASFGKG2"].ToString(); 
          or1.Parameters.Add("KASFGKG3", OracleType.NVarChar).Value = dwData["KASFGKG3"].ToString(); 
          or1.Parameters.Add("KASFGKG4", OracleType.NVarChar).Value = dwData["KASFGKG4"].ToString(); 
          or1.Parameters.Add("KASFGKG5", OracleType.NVarChar).Value = dwData["KASFGKG5"].ToString(); 
          or1.Parameters.Add("KASFFKG", OracleType.NVarChar).Value = dwData["KASFFKG"].ToString(); 
          or1.Parameters.Add("KASSEKG", OracleType.NVarChar).Value = dwData["KASSEKG"].ToString(); 
          or1.Parameters.Add("KASFEKVW1", OracleType.NVarChar).Value = dwData["KASFEKVW1"].ToString(); 
          or1.Parameters.Add("KASFEKVW2", OracleType.NVarChar).Value = dwData["KASFEKVW2"].ToString(); 
          or1.Parameters.Add("KASFEKVW3", OracleType.NVarChar).Value = dwData["KASFEKVW3"].ToString(); 
          or1.Parameters.Add("KASFEKVW4", OracleType.NVarChar).Value = dwData["KASFEKVW4"].ToString(); 
          or1.Parameters.Add("KASFEKVW5", OracleType.NVarChar).Value = dwData["KASFEKVW5"].ToString(); 
          or1.Parameters.Add("KASFGKVW1", OracleType.NVarChar).Value = dwData["KASFGKVW1"].ToString(); 
          or1.Parameters.Add("KASFGKVW2", OracleType.NVarChar).Value = dwData["KASFGKVW2"].ToString(); 
          or1.Parameters.Add("KASFGKVW3", OracleType.NVarChar).Value = dwData["KASFGKVW3"].ToString(); 
          or1.Parameters.Add("KASFGKVW4", OracleType.NVarChar).Value = dwData["KASFGKVW4"].ToString(); 
          or1.Parameters.Add("KASFGKVW5", OracleType.NVarChar).Value = dwData["KASFGKVW5"].ToString(); 
          or1.Parameters.Add("KASFFKVW", OracleType.NVarChar).Value = dwData["KASFFKVW"].ToString(); 
          or1.Parameters.Add("KASSEKVW", OracleType.NVarChar).Value = dwData["KASSEKVW"].ToString(); 
          or1.Parameters.Add("KASFEKW1", OracleType.NVarChar).Value = dwData["KASFEKW1"].ToString(); 
          or1.Parameters.Add("KASFEKW2", OracleType.NVarChar).Value = dwData["KASFEKW2"].ToString(); 
          or1.Parameters.Add("KASFEKW3", OracleType.NVarChar).Value = dwData["KASFEKW3"].ToString(); 
          or1.Parameters.Add("KASFEKW4", OracleType.NVarChar).Value = dwData["KASFEKW4"].ToString(); 
          or1.Parameters.Add("KASFEKW5", OracleType.NVarChar).Value = dwData["KASFEKW5"].ToString(); 
          or1.Parameters.Add("KASFGKW1", OracleType.NVarChar).Value = dwData["KASFGKW1"].ToString(); 
          or1.Parameters.Add("KASFGKW2", OracleType.NVarChar).Value = dwData["KASFGKW2"].ToString(); 
          or1.Parameters.Add("KASFGKW3", OracleType.NVarChar).Value = dwData["KASFGKW3"].ToString(); 
          or1.Parameters.Add("KASFGKW4", OracleType.NVarChar).Value = dwData["KASFGKW4"].ToString(); 
          or1.Parameters.Add("KASFGKW5", OracleType.NVarChar).Value = dwData["KASFGKW5"].ToString(); 
          or1.Parameters.Add("KASFFKW", OracleType.NVarChar).Value = dwData["KASFFKW"].ToString(); 
          or1.Parameters.Add("KASSEKW", OracleType.NVarChar).Value = dwData["KASSEKW"].ToString(); 
          or1.Parameters.Add("KASFEKV1", OracleType.NVarChar).Value = dwData["KASFEKV1"].ToString(); 
          or1.Parameters.Add("KASFEKV2", OracleType.NVarChar).Value = dwData["KASFEKV2"].ToString(); 
          or1.Parameters.Add("KASFEKV3", OracleType.NVarChar).Value = dwData["KASFEKV3"].ToString(); 
          or1.Parameters.Add("KASFEKV4", OracleType.NVarChar).Value = dwData["KASFEKV4"].ToString(); 
          or1.Parameters.Add("KASFEKV5", OracleType.NVarChar).Value = dwData["KASFEKV5"].ToString(); 
          or1.Parameters.Add("KASFGKV1", OracleType.NVarChar).Value = dwData["KASFGKV1"].ToString(); 
          or1.Parameters.Add("KASFGKV2", OracleType.NVarChar).Value = dwData["KASFGKV2"].ToString(); 
          or1.Parameters.Add("KASFGKV3", OracleType.NVarChar).Value = dwData["KASFGKV3"].ToString(); 
          or1.Parameters.Add("KASFGKV4", OracleType.NVarChar).Value = dwData["KASFGKV4"].ToString(); 
          or1.Parameters.Add("KASFGKV5", OracleType.NVarChar).Value = dwData["KASFGKV5"].ToString(); 
          or1.Parameters.Add("KASFFKV", OracleType.NVarChar).Value = dwData["KASFFKV"].ToString(); 
          or1.Parameters.Add("KASSEKV", OracleType.NVarChar).Value = dwData["KASSEKV"].ToString(); 
          or1.Parameters.Add("KASFEKK1", OracleType.NVarChar).Value = dwData["KASFEKK1"].ToString(); 
          or1.Parameters.Add("KASFEKK2", OracleType.NVarChar).Value = dwData["KASFEKK2"].ToString(); 
          or1.Parameters.Add("KASFEKK3", OracleType.NVarChar).Value = dwData["KASFEKK3"].ToString(); 
          or1.Parameters.Add("KASFEKK4", OracleType.NVarChar).Value = dwData["KASFEKK4"].ToString(); 
          or1.Parameters.Add("KASFEKK5", OracleType.NVarChar).Value = dwData["KASFEKK5"].ToString(); 
          or1.Parameters.Add("KASFGKK1", OracleType.NVarChar).Value = dwData["KASFGKK1"].ToString(); 
          or1.Parameters.Add("KASFGKK2", OracleType.NVarChar).Value = dwData["KASFGKK2"].ToString(); 
          or1.Parameters.Add("KASFGKK3", OracleType.NVarChar).Value = dwData["KASFGKK3"].ToString(); 
          or1.Parameters.Add("KASFGKK4", OracleType.NVarChar).Value = dwData["KASFGKK4"].ToString(); 
          or1.Parameters.Add("KASFGKK5", OracleType.NVarChar).Value = dwData["KASFGKK5"].ToString(); 
          or1.Parameters.Add("KASFFKK", OracleType.NVarChar).Value = dwData["KASFFKK"].ToString(); 
          or1.Parameters.Add("KASSEKK", OracleType.NVarChar).Value = dwData["KASSEKK"].ToString(); 
          or1.Parameters.Add("KASLAE", OracleType.NVarChar).Value = dwData["KASLAE"].ToString(); 
          or1.Parameters.Add("KASLAEBAS", OracleType.NVarChar).Value = dwData["KASLAEBAS"].ToString(); 
          or1.Parameters.Add("KASWAG", OracleType.NVarChar).Value = dwData["KASWAG"].ToString(); 
          or1.Parameters.Add("KASWAGBAS", OracleType.NVarChar).Value = dwData["KASWAGBAS"].ToString(); 
          or1.Parameters.Add("KASMEZ", OracleType.NVarChar).Value = dwData["KASMEZ"].ToString(); 
          or1.Parameters.Add("KASMEZBAS", OracleType.NVarChar).Value = dwData["KASMEZBAS"].ToString(); 
          or1.Parameters.Add("KASVERKPR", OracleType.NVarChar).Value = dwData["KASVERKPR"].ToString(); 
          or1.Parameters.Add("KASKZGZU", OracleType.NVarChar).Value = dwData["KASKZGZU"].ToString(); 
          or1.Parameters.Add("KASVVGK1", OracleType.NVarChar).Value = dwData["KASVVGK1"].ToString(); 
          or1.Parameters.Add("KASVVGK2", OracleType.NVarChar).Value = dwData["KASVVGK2"].ToString(); 
          or1.Parameters.Add("KASVVGK3", OracleType.NVarChar).Value = dwData["KASVVGK3"].ToString(); 
          or1.Parameters.Add("KASVVGK4", OracleType.NVarChar).Value = dwData["KASVVGK4"].ToString(); 
          or1.Parameters.Add("KASVVGK5", OracleType.NVarChar).Value = dwData["KASVVGK5"].ToString(); 
          or1.Parameters.Add("KASVVGK6", OracleType.NVarChar).Value = dwData["KASVVGK6"].ToString(); 
          or1.Parameters.Add("KASVVGK7", OracleType.NVarChar).Value = dwData["KASVVGK7"].ToString(); 
          or1.Parameters.Add("KASVVGK8", OracleType.NVarChar).Value = dwData["KASVVGK8"].ToString(); 
          or1.Parameters.Add("KASVVGK9", OracleType.NVarChar).Value = dwData["KASVVGK9"].ToString(); 
          or1.Parameters.Add("KASVVGK10", OracleType.NVarChar).Value = dwData["KASVVGK10"].ToString(); 
          or1.Parameters.Add("KASVERPI", OracleType.NVarChar).Value = dwData["KASVERPI"].ToString(); 
          or1.Parameters.Add("KASVERPE", OracleType.NVarChar).Value = dwData["KASVERPE"].ToString(); 
          or1.Parameters.Add("KASVERSI", OracleType.NVarChar).Value = dwData["KASVERSI"].ToString(); 
          or1.Parameters.Add("KASVERSE", OracleType.NVarChar).Value = dwData["KASVERSE"].ToString(); 
          or1.Parameters.Add("KASFRAI", OracleType.NVarChar).Value = dwData["KASFRAI"].ToString(); 
          or1.Parameters.Add("KASFRAE", OracleType.NVarChar).Value = dwData["KASFRAE"].ToString(); 
          or1.Parameters.Add("KASZOLLI", OracleType.NVarChar).Value = dwData["KASZOLLI"].ToString(); 
          or1.Parameters.Add("KASZOLLE", OracleType.NVarChar).Value = dwData["KASZOLLE"].ToString(); 
          or1.Parameters.Add("KASPROVI", OracleType.NVarChar).Value = dwData["KASPROVI"].ToString(); 
          or1.Parameters.Add("KASPROVE", OracleType.NVarChar).Value = dwData["KASPROVE"].ToString(); 
          or1.Parameters.Add("KASBONI", OracleType.NVarChar).Value = dwData["KASBONI"].ToString(); 
          or1.Parameters.Add("KASBONE", OracleType.NVarChar).Value = dwData["KASBONE"].ToString(); 
          or1.Parameters.Add("KASSKTI", OracleType.NVarChar).Value = dwData["KASSKTI"].ToString(); 
          or1.Parameters.Add("KASSKTE", OracleType.NVarChar).Value = dwData["KASSKTE"].ToString(); 
          or1.Parameters.Add("KASEVI", OracleType.NVarChar).Value = dwData["KASEVI"].ToString(); 
          or1.Parameters.Add("KASEVE", OracleType.NVarChar).Value = dwData["KASEVE"].ToString(); 
          or1.Parameters.Add("KASSEKSI", OracleType.NVarChar).Value = dwData["KASSEKSI"].ToString(); 
          or1.Parameters.Add("KASSEKSE", OracleType.NVarChar).Value = dwData["KASSEKSE"].ToString(); 
          or1.Parameters.Add("KASZINSI", OracleType.NVarChar).Value = dwData["KASZINSI"].ToString(); 
          or1.Parameters.Add("KASZINSE", OracleType.NVarChar).Value = dwData["KASZINSE"].ToString(); 
          or1.Parameters.Add("KASSDBI", OracleType.NVarChar).Value = dwData["KASSDBI"].ToString(); 
          or1.Parameters.Add("KASSDBE", OracleType.NVarChar).Value = dwData["KASSDBE"].ToString(); 
          or1.Parameters.Add("KASZUSCHLI", OracleType.NVarChar).Value = dwData["KASZUSCHLI"].ToString(); 
          or1.Parameters.Add("KASZUSCHLE", OracleType.NVarChar).Value = dwData["KASZUSCHLE"].ToString(); 
          or1.Parameters.Add("KASVPI", OracleType.NVarChar).Value = dwData["KASVPI"].ToString(); 
          or1.Parameters.Add("KASVPE", OracleType.NVarChar).Value = dwData["KASVPE"].ToString(); 
          or1.Parameters.Add("KASSCHKI", OracleType.NVarChar).Value = dwData["KASSCHKI"].ToString(); 
          or1.Parameters.Add("KASSCHKE", OracleType.NVarChar).Value = dwData["KASSCHKE"].ToString(); 
          or1.Parameters.Add("KASFILLER", OracleType.NVarChar).Value = dwData["KASFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
